prepare("select * from order_main where trans_date BETWEEN '$date1' and '$date2' ") ; $getrec->execute() ; //get sum $gsum = $DBcon->prepare("select sum(amount) as gcost from order_main where trans_date BETWEEN '$date1' and '$date2' ") ; $gsum->execute() ; $gsrow = $gsum->fetch(pdo::FETCH_ASSOC) ; $tsum = $gsrow['gcost'] ; $count = 0 ; while($row = $getrec->fetch(pdo::FETCH_ASSOC)) { $count++ ; ?>

SN	ORDER-ID	CUSTOMER	AMOUNT
		Grand Total